[dbo].[asi_GenTableByTableNameAndValue]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GenTableByTableNameAndValue

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@Code	varchar(60)	60
@TableName	varchar(30)	30

SQL Script

/****** Object:  Stored Procedure dbo.asi_GenTableByTableNameAndValue    Script Date: 7/3/2003 4:58:03 PM ******/
CREATE   PROC asi_GenTableByTableNameAndValue
@Code varchar(60),
@TableName varchar(30)

AS
BEGIN
    select * from Gen_Tables where TABLE_NAME = @TableName and ((CODE = @Code) or (SUBSTITUTE = @Code) or (UPPER_CODE = @Code))

END

GO

Uses

[dbo].[Gen_Tables]
dbo